<?php

class GlController extends Controller
{
	/**
	 * @var string the default layout for the views. Defaults to '//layouts/column2', meaning
	 * using two-column layout. See 'protected/views/layouts/column2.php'.
	 */
	public $layout='//layouts/column2';
	
	/**
	 * @var string the form input mode
	 */
	public $inputMode= '';

	
	/**
	 * @return array action filters
	 */
	public function filters()
	{
		return array(
			'accessControl', // perform access control for CRUD operations
		);
	}

	/**
	 * Specifies the access control rules.
	 * This method is used by the 'accessControl' filter.
	 * @return array access control rules
	 */
	public function accessRules()
	{
		return array(
			
			array('allow', // allow admin user to perform 'admin' and 'delete' actions
				'actions'=>array('admin','create','update','view', 'formaddrow', 'jsonview'),
				'roles'=>array('admin','accountant'),
			),
			array('deny',  // deny all users
				'users'=>array('*'),
			),
		);
	}

	/**
	 * Displays a particular model.
	 * @param integer $id the ID of the model to be displayed
	 */
	public function actionView($id)
	{
		$this->render('view',array(
			'model'=>$this->loadModel($id),
		));
	}

	/**
	 * Displays a particular model.
	 * @param integer $id the ID of the model to be displayed
	 */
	public function actionJsonView()
	{
		if(Yii::app()->request->isAjaxRequest) {
			if(!isset($_POST['id'])) {
				echo null; 
				exit;
			}
			
			$id = Yii::app()->request->getPost('id');
			echo CJSON::encode($this->loadModel($id));
			exit;
		}
			
		
	}

	
	/**
	 * Creates a new model.
	 * If creation is successful, the browser will be redirected to the 'view' page.
	 */
	public function actionCreate()
	{
		// AA 12-34-5678 
		// AA[Gl Type] [level 0]-34[level 1]-5678[level 2]
		$model = new Gl;

		// Uncomment the following line if AJAX validation is needed
		// $this->performAjaxValidation($model);
		$transaction = Yii::app()->db->beginTransaction();
		
		if(isset($_POST['Gl']))
		{
			$model->attributes=$_POST['Gl'];
			try
			{
				// level 0
				if(empty($model->parentUid)) 
				{
					$model->treeLevel = 0;
					$model->codePostfix = str_pad($model->codePostfix, 7, "0", STR_PAD_RIGHT);;
					$model->parentUid = NULL;
					
					$exitingGl = Gl::model()->findAll(array('condition'=>"codePrefix='$model->codePrefix' AND codePostfix=$model->codePostfix"));
					if(count($exitingGl) > 0)
					{
						throw new CException('Code postfix already exist.');
					}	
				} 
				else 
				{
					$parentModel = $this->loadModel($model->parentUid);
					$model->glType = $parentModel->glType;
					$model->codePrefix = $parentModel->codePrefix;
					$model->treeLevel = $parentModel->treeLevel + 1;

					// set code postfix
					$criteria=new CDbCriteria;
					$criteria->select='max(codePostfix) as codePostfix';
					$criteria->condition = 'codePrefix=:codePrefix AND parentUid=:parentUid';
					$criteria->params = array(':codePrefix'=>$model->codePrefix, ':parentUid'=>$model->parentUid);
					$maxCodePostfixRow = Gl::model()->find($criteria);
					$model->codePostfix = $maxCodePostfixRow['codePostfix'];
					if($model->codePostfix == NULL || $model->codePostfix == 'auto')
						$model->codePostfix = $parentModel->codePostfix;
						
					if($model->treeLevel == 1)
					{
						$model->codePostfix = $model->codePostfix + 10000;
					}
					else
					{
						$model->codePostfix = $model->codePostfix + 1;
					}
				}
				
				// echo CJSON::encode($model);
				if($model->save())
				{
					$transaction->commit();
					$this->redirect(array('view','id'=>$model->id));
				}
				
			} catch (Exception $ex) {
				$transaction->rollback();
				$errorCount = count($model->getErrors());
				$model->addError($errorCount, $ex->getMessage());
				Yii::log($ex->getMessage(), CLogger::LEVEL_ERROR, __METHOD__);
			}
		}
		
		$this->render('create',array(
			'model'=>$model,
			'modelGl'=>$modelGl,
		));
	}
	
	/**
	 * creates a new model row for tabular form.
	 * will show tabular form with new row.
	 */
	public function actionFormAddRow()
	{
		if(Yii::app()->request->isAjaxRequest) {
			$items = Yii::app()->request->getPost('Gl');
			
			$modelGl = array();
			
			if (is_array($items)) { 
				//creating existing model instances + setting attributes
				foreach ($items as $i => $item) {
					$modelGl[$i] = new Gl();
					$modelGl[$i]->setAttributes($item);
				}
			}
            //creating an additional empty model instance
            $modelGl[] = new Gl();
            
            echo $this->renderPartial('application.views.gl/_tabularform_additional', array("modelGl" => $modelGl));
            exit;

        } else {
            throw new CHttpException(404, 'Unable to resolve the request');
        }
	}
	
	/**
	 * Updates a particular model.
	 * If update is successful, the browser will be redirected to the 'view' page.
	 * @param integer $id the ID of the model to be updated
	 */
	public function actionUpdate($id)
	{
		$model = $this->loadModel($id);

		// Uncomment the following line if AJAX validation is needed
		// $this->performAjaxValidation($model);

		if(isset($_POST['Gl']))
		{
			$model->attributes=$_POST['Gl'];
				
			if($model->save())
				$this->redirect(array('view','id'=>$model->id));
		}
		
		$this->inputMode = 'edit';
		$this->render('update',array(
			'model'=>$model,
		));
	}

	/**
	 * Deletes a particular model.
	 * If deletion is successful, the browser will be redirected to the 'admin' page.
	 * @param integer $id the ID of the model to be deleted
	 */
	public function actionDelete($id)
	{
		if(Yii::app()->request->isPostRequest)
		{
			// we only allow deletion via POST request
			$this->loadModel($id)->delete();

			// if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
			if(!isset($_GET['ajax']))
				$this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('admin'));
		}
		else
			throw new CHttpException(400,'Invalid request. Please do not repeat this request again.');
	}

	/**
	 * Lists all models.
	 */
	public function actionIndex()
	{
		$dataProvider=new CActiveDataProvider('Gl');
		$this->render('index',array(
			'dataProvider'=>$dataProvider,
		));
	}

	/**
	 * Manages all models.
	 */
	public function actionAdmin()
	{
		$model=new Gl('search');
		$model->unsetAttributes();  // clear any default values
		if(isset($_GET['Gl']))
			$model->attributes=$_GET['Gl'];

		$this->render('admin',array(
			'model'=>$model,
		));
	}

	/**
	 * Returns the data model based on the primary key given in the GET variable.
	 * If the data model is not found, an HTTP exception will be raised.
	 * @param integer the ID of the model to be loaded
	 */
	public function loadModel($id)
	{
		$model=Gl::model()->findByPk($id);
		if($model===null)
			throw new CHttpException(404,'The requested page does not exist.');
		return $model;
	}

	/**
	 * Performs the AJAX validation.
	 * @param CModel the model to be validated
	 */
	protected function performAjaxValidation($model)
	{
		if(isset($_POST['ajax']) && $_POST['ajax']==='gl-form')
		{
			echo CActiveForm::validate($model);
			Yii::app()->end();
		}
	}
}
